table lock

• Table locking behavior
  表锁定行为
• Read operations acquire no page or row locks ; only sch - s table locks are acquired
  读取操作不获取页锁或行锁，只获取sch - s表锁。
• The following partial transaction shows how to place an explicit shared table lock on
  上放置一个显式共享表锁，以及如何读取索引。
• Table locks are applied and the table is unavailable for the duration of the index operation
  应用表锁，该表在索引操作期间不可用。
• Exclusive table locks are held only for a very short amount of time during the alteration process
  更改过程中，排他表锁只保留非常短的时间。
• The sql server 2005 database engine will not escalate row or page locks to table locks
  Sql server 2005数据库引擎不会将行锁或页锁升级到表锁。
• Sets the locking behavior for a table during a bulk - import operation . table lock on bulk import
  选项可以设置大容量导入操作过程中针对表的锁定行为。
• If holdlock is also specified , the shared table lock is held until the end of the transaction
  如果同时指定了holdlock ，那么，在事务结束之前将一直保持该共享表锁。
• Causes dbcc checktable to obtain a shared table lock instead of using an internal database snapshot
  可使dbcc checktable获得一个共享表锁，而不使用内部数据库快照。
• Table locking can improve performance of the bulk - import operation by reducing lock contention on the table
  表锁定可以通过减少表中的锁争用来提高大容量导入操作的性能。